<?php


// Check to ensure this file is included in Joomla!
defined('_JEXEC') or die();

jimport( 'joomla.application.component.model' );

//nombreControlador_MODEL_nombreModelo
class AplicacionModelSitio extends JModel
{
	var $sitio;
	
    function getSitio($idSitio)
    {   	 	
    	$query='select s.titulo as titulo,
    					s.url as url,
    					s.foto as foto,
    					s.video as video,
    					s.n_votos as n_votos,
    					s.no_apropiado as no_apropiado,
    					s.google_x as google_x,
    					s.google_y as google_y,
    					s.fecha_ins as fecha_ins,
    					s.publicar as publicar,
    					c.nombre as categoria,
    					u.username as usuario,
    					u.id as idusuario  
    			from jos_zsitio s, jos_zcategoria c, jos_users u 
    			where s.id=' . $idSitio . ' 
    					and s.usuario=u.id 
    					and s.categoria=c.id';
    	$this->sitio=& $this->_getList($query);    
    	return $this->sitio;
    }
  
    /*function getTagsSitio($idSitio)
    {
		$query= 'select a.id as idarticulo,
							a.titulo as titulo,
							a.texto as texto,
							a.publicar as publicar,
							a.n_votos as n_votos,
							a.no_apropiado as no_apropiado,
							a.fecha_ins as fecha_ins,
							u.username as username,
					from #__zarticulo a, #__users u 
					where u.id
							';
		$this->LSitios[1][$cont]=$this->_getList($query2);
    }*/
}
?>